insert
overwrite
table
jms_dim.dim_yl_oms_order_interceptor_hi
select
ID,
DATA_TYPE,
IS_ENABLE,
SERVICE_TYPE,
ABNORMAL_REASON_CODE ,
ABNORMAL_REASON,
ABNORMAL_DESC ,
NETWORK_CODE,
NETWORK_NAME ,
PROVINCE ,
PROVINCE_ID ,
CITY string,
CITY_ID string,
AREA string,
AREA_ID string ,
THE_THIRD_CODE,
EFFECT_TIME_TYPE ,
EFFECT_TIME_START,
EFFECT_TIME_END,
IS_DELETE bigint,
CREATE_USER string,
CREATE_TIME timestamp,
UPDATE_USER string,
UPDATE_TIME timestamp,
OPERATION_TYPE_NAME ,
BELONG_PROXY string,
BELONG_PROXY_CODE,
EXPECTED_EFFECT_TIME_START,
EXPECTED_EFFECT_TIME_END
from jms_ods.yl_oms_order_interceptor_hi
where dt = '{{ execution_date | cst_hour }}';